﻿using System;
using System.Collections.Generic;
using System.ComponentModel.DataAnnotations;
using System.ComponentModel.DataAnnotations.Schema;

namespace housingsafety.server.Models
{
    public class HelperModel
    {
        [Table("zm_pc_yhlog_sqjz")]
        public partial class ZmPcYhLogSqjz
        {

            [Key]
            [Column("id")]
            [StringLength(50)]
            public string Id { get; set; }

            [Column("fwbh")]
            [StringLength(50)]
            public string? Fwbh { get; set; }

            // 下面是第二个表的字段信息
            [Column("pczt")]
            public short? Pczt { get; set; }


            // 下面是第二个表的字段信息
            [Column("pc_yh_id")]
            public string? PcYhId { get; set; }


            // 下面是第二个表的字段信息
            [Column("base_id")]
            public string? BaseId { get; set; }

            [Column("jcly")]
            public short? Jcly { get; set; }

            [Column("use_electric_bicycle")]
            public short? UseElectricBicycle { get; set; }

            [Column("use_bottled_liquefied_gas")]
            public short? UseBottledLiquefiedGas { get; set; }

            [Column("use_stacked_items")]
            public short? UseStackedItems { get; set; }

            [Column("mhqwbcwhyx")]
            public short? Mhqwbcwhyx { get; set; }

            [Column("jyplmhxtwbcwhyx")]
            public short? Jyplmhxtwbcwhyx { get; set; }

            [Column("ygbjwfwhyx")]
            public short? Ygbjwfwhyx { get; set; }

            [Column("use_electric_bicycle_photo", TypeName = "json")]
            public string? UseElectricBicyclePhoto { get; set; }

            [Column("use_bottled_liquefied_gas_photo", TypeName = "json")]

            public string? UseBottledLiquefiedGasPhoto { get; set; }

            [Column("use_stacked_items_photo", TypeName = "json")]

            public string? UseStackedItemsPhoto { get; set; }

            [Column("mhqwbcwhyx_photo", TypeName = "json")]

            public string? MhqwbcwhyxPhoto { get; set; }

            [Column("jyplmhxtwbcwhyx_photo", TypeName = "json")]

            public string? JyplmhxtwbcwhyxPhoto { get; set; }

            [Column("ygbjwfwhyx_photo", TypeName = "json")]

            public string? YgbjwfwhyxPhoto { get; set; }

            [Column("use_electric_bicycle_msg")]
            [StringLength(1000)]
            public string? UseElectricBicycleMsg { get; set; }

            [Column("use_bottled_liquefied_gas_msg")]
            [StringLength(1000)]
            public string? UseBottledLiquefiedGasMsg { get; set; }

            [Column("use_stacked_items_msg")]
            [StringLength(1000)]
            public string? UseStackedItemsMsg { get; set; }

            [Column("mhqwbcwhyx_msg")]
            [StringLength(1000)]
            public string? MhqwbcwhyxMsg { get; set; }

            [Column("jyplmhxtwbcwhyx_msg")]
            [StringLength(1000)]
            public string? JyplmhxtwbcwhyxMsg { get; set; }

            [Column("ygbjwfwhyx_msg")]
            [StringLength(1000)]
            public string? YgbjwfwhyxMsg { get; set; }

            [Column("use_electric_bicycle_zgqk")]
            public short? UseElectricBicycleZgqk { get; set; }

            [Column("use_bottled_liquefied_gas_zgqk")]
            public short? UseBottledLiquefiedGasZgqk { get; set; }

            [Column("use_stacked_items_zgqk")]
            public short? UseStackedItemsZgqk { get; set; }

            [Column("mhqwbcwhyx_zgqk")]
            public short? MhqwbcwhyxZgqk { get; set; }

            [Column("jyplmhxtwbcwhyx_zgqk")]
            public short? JyplmhxtwbcwhyxZgqk { get; set; }

            [Column("ygbjwfwhyx_msg_zgqk")]
            public short? YgbjwfwhyxMsgZgqk { get; set; }

            [Column("use_electric_bicycle_zgphoto", TypeName = "json")]

            public string? UseElectricBicycleZgPhoto { get; set; }

            [Column("use_bottled_liquefied_gas_zgphoto", TypeName = "json")]

            public string? UseBottledLiquefiedGasZgPhoto { get; set; }

            [Column("use_stacked_items_zgphoto", TypeName = "json")]

            public string? UseStackedItemsZgPhoto { get; set; }

            [Column("mhqwbcwhyx_zgphoto", TypeName = "json")]

            public string? MhqwbcwhyxZgPhoto { get; set; }

            [Column("jyplmhxtwbcwhyx_zgphoto", TypeName = "json")]

            public string? JyplmhxtwbcwhyxZgPhoto { get; set; }

            [Column("ygbjwfwhyx_msg_zgphoto", TypeName = "json")]

            public string? YgbjwfwhyxMsgZgPhoto { get; set; }

            [Column("slljdx")]
            public short? Slljdx { get; set; }

            [Column("slljdx_photo", TypeName = "json")]

            public string? SlljdxPhoto { get; set; }

            [Column("slljdx_msg")]
            [StringLength(255)]
            public string? SlljdxMsg { get; set; }

            [Column("slljdx_zgqk")]
            public short? SlljdxZgqk { get; set; }

            [Column("slljdx_zgphoto", TypeName = "json")]

            public string? SlljdxZgPhoto { get; set; }

            [Column("zxqlddcsl")]
            public short? Zxqlddcsl { get; set; }

            [Column("zxqlyhsyqsl")]
            public short? Zxqlyhsyqsl { get; set; }

            [Column("sign")]
            [StringLength(255)]
            public string? Sign { get; set; }

            [Column("notes")]
            [StringLength(255)]
            public string? Notes { get; set; }

            [Column("create_by")]
            [StringLength(50)]
            public string? CreateBy { get; set; }

            [Column("create_on")]
            public DateTime CreateOn { get; set; }

            [Column("create_ip")]
            [StringLength(20)]
            public string? CreateIp { get; set; }

            [Column("modified_by")]
            [StringLength(50)]
            public string? ModifiedBy { get; set; }

            [Column("modified_on")]
            public DateTime? ModifiedOn { get; set; }

            [Column("modified_ip")]
            [StringLength(20)]
            public string? ModifiedIp { get; set; }

            [Column("is_delete")]
            public short? IsDelete { get; set; }

            [Column("delete_by")]
            [StringLength(50)]
            public string? DeleteBy { get; set; }

            [Column("delete_on")]
            public DateTime? DeleteOn { get; set; }

            [Column("delete_ip")]
            [StringLength(20)]
            public string? DeleteIp { get; set; }

            [Column("pcsj")]
            [StringLength(255)]
            public DateTime? Pcsj { get; set; }

            [Column("jczt")]
            [StringLength(255)]
            public string? Jczt { get; set; }


            [Column("txxxysjbf")]
            public int? Txxxysjbf { get; set; }


            [Column("bzsm")]
            public string? Bzsm { get; set; }

            [Column("xzqdm")]
            public string? Xzqdm { get; set; }

            [Column("town")]
            public string? Town { get; set; }

            [Column("village")]
            public string? Village { get; set; }


            [Column("xzq")]
            public string? Xzq { get; set; }

            [Column("towndm")]
            public string? Towndm { get; set; }

            [Column("villagedm")]
            public string? Villagedm { get; set; }

        }

        [Table("zm_pc_yhlog")]
        public partial class ZmPcYhLog
        {

            [Key]
            [Column("id")]
            [StringLength(50)]
            public string Id { get; set; }

            [Column("fwbh")]
            [StringLength(50)]
            public string? Fwbh { get; set; }

            // 下面是第二个表的字段信息
            [Column("pczt")]
            public short? Pczt { get; set; }


            // 下面是第二个表的字段信息
            [Column("pc_yh_id")]
            public string? PcYhId { get; set; }


            // 下面是第二个表的字段信息
            [Column("base_id")]
            public string? BaseId { get; set; }

            [Column("jcly")]
            public short? Jcly { get; set; }

            [Column("use_electric_bicycle")]
            public short? UseElectricBicycle { get; set; }

            [Column("use_bottled_liquefied_gas")]
            public short? UseBottledLiquefiedGas { get; set; }

            [Column("use_stacked_items")]
            public short? UseStackedItems { get; set; }

            [Column("mhqwbcwhyx")]
            public short? Mhqwbcwhyx { get; set; }

            [Column("jyplmhxtwbcwhyx")]
            public short? Jyplmhxtwbcwhyx { get; set; }

            [Column("ygbjwfwhyx")]
            public short? Ygbjwfwhyx { get; set; }

            [Column("use_electric_bicycle_photo", TypeName = "json")]
            public string? UseElectricBicyclePhoto { get; set; }

            [Column("use_bottled_liquefied_gas_photo", TypeName = "json")]

            public string? UseBottledLiquefiedGasPhoto { get; set; }

            [Column("use_stacked_items_photo", TypeName = "json")]

            public string? UseStackedItemsPhoto { get; set; }

            [Column("mhqwbcwhyx_photo", TypeName = "json")]

            public string? MhqwbcwhyxPhoto { get; set; }

            [Column("jyplmhxtwbcwhyx_photo", TypeName = "json")]

            public string? JyplmhxtwbcwhyxPhoto { get; set; }

            [Column("ygbjwfwhyx_photo", TypeName = "json")]

            public string? YgbjwfwhyxPhoto { get; set; }

            [Column("use_electric_bicycle_msg")]
            [StringLength(1000)]
            public string? UseElectricBicycleMsg { get; set; }

            [Column("use_bottled_liquefied_gas_msg")]
            [StringLength(1000)]
            public string? UseBottledLiquefiedGasMsg { get; set; }

            [Column("use_stacked_items_msg")]
            [StringLength(1000)]
            public string? UseStackedItemsMsg { get; set; }

            [Column("mhqwbcwhyx_msg")]
            [StringLength(1000)]
            public string? MhqwbcwhyxMsg { get; set; }

            [Column("jyplmhxtwbcwhyx_msg")]
            [StringLength(1000)]
            public string? JyplmhxtwbcwhyxMsg { get; set; }

            [Column("ygbjwfwhyx_msg")]
            [StringLength(1000)]
            public string? YgbjwfwhyxMsg { get; set; }

            [Column("use_electric_bicycle_zgqk")]
            public short? UseElectricBicycleZgqk { get; set; }

            [Column("use_bottled_liquefied_gas_zgqk")]
            public short? UseBottledLiquefiedGasZgqk { get; set; }

            [Column("use_stacked_items_zgqk")]
            public short? UseStackedItemsZgqk { get; set; }

            [Column("mhqwbcwhyx_zgqk")]
            public short? MhqwbcwhyxZgqk { get; set; }

            [Column("jyplmhxtwbcwhyx_zgqk")]
            public short? JyplmhxtwbcwhyxZgqk { get; set; }

            [Column("ygbjwfwhyx_msg_zgqk")]
            public short? YgbjwfwhyxMsgZgqk { get; set; }

            [Column("use_electric_bicycle_zgphoto", TypeName = "json")]

            public string? UseElectricBicycleZgPhoto { get; set; }

            [Column("use_bottled_liquefied_gas_zgphoto", TypeName = "json")]

            public string? UseBottledLiquefiedGasZgPhoto { get; set; }

            [Column("use_stacked_items_zgphoto", TypeName = "json")]

            public string? UseStackedItemsZgPhoto { get; set; }

            [Column("mhqwbcwhyx_zgphoto", TypeName = "json")]

            public string? MhqwbcwhyxZgPhoto { get; set; }

            [Column("jyplmhxtwbcwhyx_zgphoto", TypeName = "json")]

            public string? JyplmhxtwbcwhyxZgPhoto { get; set; }

            [Column("ygbjwfwhyx_msg_zgphoto", TypeName = "json")]

            public string? YgbjwfwhyxMsgZgPhoto { get; set; }

            [Column("slljdx")]
            public short? Slljdx { get; set; }

            [Column("slljdx_photo", TypeName = "json")]

            public string? SlljdxPhoto { get; set; }

            [Column("slljdx_msg")]
            [StringLength(255)]
            public string? SlljdxMsg { get; set; }

            [Column("slljdx_zgqk")]
            public short? SlljdxZgqk { get; set; }

            [Column("slljdx_zgphoto", TypeName = "json")]

            public string? SlljdxZgPhoto { get; set; }

            [Column("zxqlddcsl")]
            public short? Zxqlddcsl { get; set; }

            [Column("zxqlyhsyqsl")]
            public short? Zxqlyhsyqsl { get; set; }

            [Column("sign")]
            [StringLength(255)]
            public string? Sign { get; set; }

            [Column("notes")]
            [StringLength(255)]
            public string? Notes { get; set; }

            [Column("create_by")]
            [StringLength(50)]
            public string? CreateBy { get; set; }

            [Column("create_on")]
            public DateTime CreateOn { get; set; }

            [Column("create_ip")]
            [StringLength(20)]
            public string? CreateIp { get; set; }

            [Column("modified_by")]
            [StringLength(50)]
            public string? ModifiedBy { get; set; }

            [Column("modified_on")]
            public DateTime? ModifiedOn { get; set; }

            [Column("modified_ip")]
            [StringLength(20)]
            public string? ModifiedIp { get; set; }

            [Column("is_delete")]
            public short? IsDelete { get; set; }

            [Column("delete_by")]
            [StringLength(50)]
            public string? DeleteBy { get; set; }

            [Column("delete_on")]
            public DateTime? DeleteOn { get; set; }

            [Column("delete_ip")]
            [StringLength(20)]
            public string? DeleteIp { get; set; }

            [Column("pcsj")]
            [StringLength(255)]
            public DateTime? Pcsj { get; set; }

            [Column("jczt")]
            [StringLength(255)]
            public string? Jczt { get; set; }
        }


        [Table("zm_pc_baselog")]
        public partial class ZmPcBaseLog
        {
            [Key]
            [Column("id")]
            [StringLength(50)]
            public string Id { get; set; }

            [Column("fwbh")]
            [StringLength(50)]
            public string Fwbh { get; set; }

            //[Column("city")]
            //[StringLength(6)]
            //public string City { get; set; }
            [Column("cjzwqtjyyt")]
            public int? Cjzwqtjyyt { get; set; }
            [Column("xzqdm")]
            [StringLength(6)]
            public string Xzqdm { get; set; }

            [Column("town")]
            [StringLength(12)]
            public string Town { get; set; }

            [Column("village")]
            [StringLength(12)]
            public string Village { get; set; }



            [Column("xzq")]
            [StringLength(6)]
            public string Xzqname { get; set; }

            [Column("towndm")]
            [StringLength(12)]
            public string Townname { get; set; }

            [Column("villagedm")]
            [StringLength(12)]
            public string Villagename { get; set; }

            [Column("address")]
            [StringLength(254)]
            public string Address { get; set; }

            [Column("yhfwbh")]
            [StringLength(36)]
            public string Yhfwbh { get; set; }

            [Column("hzxm")]
            [StringLength(36)]
            public string Hzxm { get; set; }

            [Column("cs")]
            public long? Cs { get; set; }

            [Column("jzrks")]
            public int? Jzrks { get; set; }

            [Column("zzrs")]
            public int? Zzrs { get; set; }

            [Column("jzfjs")]
            public int? Jzfjs { get; set; }

            [Column("fjsl")]
            public int? Fjsl { get; set; }

            [Column("jzscxyaqcksl")]
            public int? Jzscxyaqcksl { get; set; }

            [Column("jzscmj")]
            public decimal? Jzscmj { get; set; }

            [Column("jzszlwxdlgybjqs")]
            public int? Jzszlwxdlgybjqs { get; set; }

            [Column("jzsyjyplmhxts")]
            public int? Jzsyjyplmhxts { get; set; }

            [Column("jzxyssltsl")]
            public int? Jzxyssltsl { get; set; }

            [Column("mhqsl")]
            public int? Mhqsl { get; set; }

            [Column("fytsmz")]
            public int? Fytsmz { get; set; }

            [Column("xggdjsbp")]
            public int? Xggdjsbp { get; set; }

            [Column("jsrysstd")]
            [StringLength(100)]
            public string Jsrysstd { get; set; }

            //[Column("sfazzzryslpbfytsmd")]
            //public int? Sfazzzryslpbfytsmd { get; set; }

            [Column("cjzwqtjyytmsg")]
            [StringLength(100)]
            public string Cjzwqtjyytmsg { get; set; }

            [Column("ckfhwggptzlsl")]
            public int? Ckfhwggptzlsl { get; set; }

            [Column("gryssdcsszblyyqksddp")]
            public int? Gryssdcsszblyyqksddp { get; set; }

            [Column("wdwhjgfjgqsyyrkrgbdj")]
            public int? Wdwhjgfjgqsyyrkrgbdj { get; set; }

            [Column("sstdjsqk")]
            [StringLength(100)]
            public string Sstdjsqk { get; set; }

            [Column("create_by")]
            [StringLength(50)]
            public string CreateBy { get; set; }

            [Column("create_on")]
            public DateTime CreateOn { get; set; }

            [Column("create_ip")]
            [StringLength(20)]
            public string CreateIp { get; set; }

            [Column("modified_by")]
            [StringLength(50)]
            public string ModifiedBy { get; set; }

            [Column("modified_on")]
            public DateTime? ModifiedOn { get; set; }

            [Column("modified_ip")]
            [StringLength(20)]
            public string ModifiedIp { get; set; }

            [Column("is_delete")]
            public short? IsDelete { get; set; }

            [Column("delete_by")]
            [StringLength(50)]
            public string DeleteBy { get; set; }

            [Column("delete_on")]
            public DateTime? DeleteOn { get; set; }

            [Column("delete_ip")]
            [StringLength(20)]
            public string DeleteIp { get; set; }

            [Column("bdfwjzrydddzxcsl")]
            public int? Bdfwjzrydddzxcsl { get; set; }

            [Column("sstdsyyrkrclzx")]
            public int? Sstdsyyrkrclzx { get; set; }

            [Column("pcsj")]
            public DateTime? Pcsj { get; set; }

            [Column("yhly")]
            public int? Yhly { get; set; }


            [Column("cdfs")]
            public string? Cdfs { get; set; }


            [Column("cdfsqtbz")]
            public string? Cdfsqtbz { get; set; }

            [Column("czryrs")]
            public int? Czryrs { get; set; }

            [Column("fwzt")]
            public string? Fwzt { get; set; }


            [Column("sfazfztsss")]
            public int? Sfazfztsss { get; set; }



            [Column("ywgdlttxwd")]
            public int? Ywgdlttxwd { get; set; }
        }

        [Table("zm_pc_baselog_sqjz")]
        public partial class ZmPcBaseLogSqjz : Repository.IEntity
        {
            [Key]
            [Column("id")]
            [StringLength(50)]
            public string Id { get; set; }

            [Column("fwbh")]
            [StringLength(50)]
            public string Fwbh { get; set; }

            //[Column("city")]
            //[StringLength(6)]
            //public string City { get; set; }
            [Column("cjzwqtjyyt")]
            public int? Cjzwqtjyyt { get; set; }

            [Column("xzqdm")]
            public string? Xzqdm { get; set; }

            [Column("town")]
            public string? Town { get; set; }

            [Column("village")]
            public string? Village { get; set; }


            [Column("xzq")]
            [StringLength(6)]
            public string Xzqname { get; set; }

            [Column("towndm")]
            [StringLength(12)]
            public string Townname { get; set; }

            [Column("villagedm")]
            [StringLength(12)]
            public string Villagename { get; set; }

            //[Column("xzq")]
            //public string? Xzq { get; set; }

            //[Column("towndm")]
            //public string? Towndm { get; set; }

            //[Column("villagedm")]
            //public string? Villagedm { get; set; }

            [Column("address")]
            [StringLength(254)]
            public string Address { get; set; }

            [Column("yhfwbh")]
            [StringLength(36)]
            public string Yhfwbh { get; set; }

            [Column("hzxm")]
            [StringLength(36)]
            public string Hzxm { get; set; }

            [Column("cs")]
            public long? Cs { get; set; }

            [Column("jzrks")]
            public int? Jzrks { get; set; }

            [Column("zzrs")]
            public int? Zzrs { get; set; }

            [Column("jzfjs")]
            public int? Jzfjs { get; set; }

            [Column("fjsl")]
            public int? Fjsl { get; set; }

            [Column("jzscxyaqcksl")]
            public int? Jzscxyaqcksl { get; set; }

            [Column("jzscmj")]
            public decimal? Jzscmj { get; set; }

            [Column("jzszlwxdlgybjqs")]
            public int? Jzszlwxdlgybjqs { get; set; }

            [Column("jzsyjyplmhxts")]
            public int? Jzsyjyplmhxts { get; set; }

            [Column("jzxyssltsl")]
            public int? Jzxyssltsl { get; set; }

            [Column("mhqsl")]
            public int? Mhqsl { get; set; }

            [Column("fytsmz")]
            public int? Fytsmz { get; set; }

            [Column("xggdjsbp")]
            public int? Xggdjsbp { get; set; }

            [Column("jsrysstd")]
            [StringLength(100)]
            public string Jsrysstd { get; set; }

            //[Column("sfazzzryslpbfytsmd")]
            //public int? Sfazzzryslpbfytsmd { get; set; }

            [Column("cjzwqtjyytmsg")]
            [StringLength(100)]
            public string Cjzwqtjyytmsg { get; set; }

            [Column("ckfhwggptzlsl")]
            public int? Ckfhwggptzlsl { get; set; }

            [Column("gryssdcsszblyyqksddp")]
            public int? Gryssdcsszblyyqksddp { get; set; }

            [Column("wdwhjgfjgqsyyrkrgbdj")]
            public int? Wdwhjgfjgqsyyrkrgbdj { get; set; }

            [Column("sstdjsqk")]
            [StringLength(100)]
            public string Sstdjsqk { get; set; }

            [Column("create_by")]
            [StringLength(50)]
            public string CreateBy { get; set; }

            [Column("create_on")]
            public DateTime CreateOn { get; set; }

            [Column("create_ip")]
            [StringLength(20)]
            public string CreateIp { get; set; }

            [Column("modified_by")]
            [StringLength(50)]
            public string ModifiedBy { get; set; }

            [Column("modified_on")]
            public DateTime? ModifiedOn { get; set; }

            [Column("modified_ip")]
            [StringLength(20)]
            public string ModifiedIp { get; set; }

            [Column("is_delete")]
            public short? IsDelete { get; set; }

            [Column("delete_by")]
            [StringLength(50)]
            public string DeleteBy { get; set; }

            [Column("delete_on")]
            public DateTime? DeleteOn { get; set; }

            [Column("delete_ip")]
            [StringLength(20)]
            public string DeleteIp { get; set; }

            [Column("bdfwjzrydddzxcsl")]
            public int? Bdfwjzrydddzxcsl { get; set; }

            [Column("sstdsyyrkrclzx")]
            public int? Sstdsyyrkrclzx { get; set; }

            [Column("pcsj")]
            public DateTime? Pcsj { get; set; }

            [Column("yhly")]
            public int? Yhly { get; set; }


            [Column("fwyfwdddzxccdsssfayqjshsf")]
            public int? Fwyfwdddzxccdsssfayqjshsf { get; set; }

            [Column("sfszsszsbzhaqckbz")]
            public int? Sfszsszsbzhaqckbz { get; set; }

            [Column("fwzt")]
            public int? Fwzt { get; set; }

            [Column("cdfs")]
            public string? Cdfs { get; set; }

            [Column("cdfsqtbz")]
            public string? Cdfsqtbz { get; set; }


            [Column("czryrs")]
            public int? Czryrs { get; set; }
            [Column("create_name")]
            public string? CreateName { get; set; }
            [Column("sfyzc")]
            public string? Sfyzc { get; set; }
            [Column("tdsfdb")]
            public string? Tdsfdb { get; set; }


            [Column("sfazfztsss")]
            public int? Sfazfztsss { get; set; }



            [Column("ywgdlttxwd")]
            public int? Ywgdlttxwd { get; set; }
        }

        /// <summary>
        /// 分页查询
        /// </summary>
        public class PageHouseRequestInputCj
        {
            /// <summary>
            /// 页码从0开始
            /// </summary>
            public List<DateTime> CheckTime { get; set; }
            /// <summary>
            /// 页码从0开始
            /// </summary>
            public string Villagedm { get; set; }

            public string Text { get; set; }

            //1wu隐患 2 有隐患
            public int Pczt { get; set; } = 0;

            public int Yhly { get; set; } = 0;
            //1已自查 2 未自查
            public int Zczt { get; set; } = 0;

            //1已检查 2 未检查
            public int Jczt { get; set; } = 0;

            //1已核查 2 未核查
            public int Hczt { get; set; } = 0;

            public string Towndm { get; set; }

            public string Xzqdm { get; set; }
            /// <summary>
            /// 页码从0开始
            /// </summary>
            public int PageIndex { get; set; } = 0;

            /// <summary>
            /// 每页个数
            /// </summary>
            public int Limit { get; set; } = 50;

        }
        [Table("zm_pc_yhlog_cj")]
        public partial class ZmPcYhLogCj : Repository.IEntity
        {

            [Key]
            [Column("id")]
            [StringLength(50)]
            public string Id { get; set; }

            [Column("fwbh")]
            [StringLength(50)]
            public string? Fwbh { get; set; }

            // 下面是第二个表的字段信息
            [Column("pczt")]
            public short? Pczt { get; set; }


            // 下面是第二个表的字段信息
            [Column("pc_yh_id")]
            public string? PcYhId { get; set; }


            // 下面是第二个表的字段信息
            [Column("base_id")]
            public string? BaseId { get; set; }

            [Column("jcly")]
            public short? Jcly { get; set; }

            [Column("use_electric_bicycle")]
            public short? UseElectricBicycle { get; set; }

            [Column("use_bottled_liquefied_gas")]
            public short? UseBottledLiquefiedGas { get; set; }

            [Column("use_stacked_items")]
            public short? UseStackedItems { get; set; }

            [Column("mhqwbcwhyx")]
            public short? Mhqwbcwhyx { get; set; }

            [Column("jyplmhxtwbcwhyx")]
            public short? Jyplmhxtwbcwhyx { get; set; }

            [Column("ygbjwfwhyx")]
            public short? Ygbjwfwhyx { get; set; }

            [Column("use_electric_bicycle_photo", TypeName = "json")]
            public string? UseElectricBicyclePhoto { get; set; }

            [Column("use_bottled_liquefied_gas_photo", TypeName = "json")]

            public string? UseBottledLiquefiedGasPhoto { get; set; }

            [Column("use_stacked_items_photo", TypeName = "json")]

            public string? UseStackedItemsPhoto { get; set; }

            [Column("mhqwbcwhyx_photo", TypeName = "json")]

            public string? MhqwbcwhyxPhoto { get; set; }

            [Column("jyplmhxtwbcwhyx_photo", TypeName = "json")]

            public string? JyplmhxtwbcwhyxPhoto { get; set; }

            [Column("ygbjwfwhyx_photo", TypeName = "json")]

            public string? YgbjwfwhyxPhoto { get; set; }

            [Column("use_electric_bicycle_msg")]
            [StringLength(1000)]
            public string? UseElectricBicycleMsg { get; set; }

            [Column("use_bottled_liquefied_gas_msg")]
            [StringLength(1000)]
            public string? UseBottledLiquefiedGasMsg { get; set; }

            [Column("use_stacked_items_msg")]
            [StringLength(1000)]
            public string? UseStackedItemsMsg { get; set; }

            [Column("mhqwbcwhyx_msg")]
            [StringLength(1000)]
            public string? MhqwbcwhyxMsg { get; set; }

            [Column("jyplmhxtwbcwhyx_msg")]
            [StringLength(1000)]
            public string? JyplmhxtwbcwhyxMsg { get; set; }

            [Column("ygbjwfwhyx_msg")]
            [StringLength(1000)]
            public string? YgbjwfwhyxMsg { get; set; }

            [Column("use_electric_bicycle_zgqk")]
            public short? UseElectricBicycleZgqk { get; set; }

            [Column("use_bottled_liquefied_gas_zgqk")]
            public short? UseBottledLiquefiedGasZgqk { get; set; }

            [Column("use_stacked_items_zgqk")]
            public short? UseStackedItemsZgqk { get; set; }

            [Column("mhqwbcwhyx_zgqk")]
            public short? MhqwbcwhyxZgqk { get; set; }

            [Column("jyplmhxtwbcwhyx_zgqk")]
            public short? JyplmhxtwbcwhyxZgqk { get; set; }

            [Column("ygbjwfwhyx_msg_zgqk")]
            public short? YgbjwfwhyxMsgZgqk { get; set; }

            [Column("use_electric_bicycle_zgphoto", TypeName = "json")]

            public string? UseElectricBicycleZgPhoto { get; set; }

            [Column("use_bottled_liquefied_gas_zgphoto", TypeName = "json")]

            public string? UseBottledLiquefiedGasZgPhoto { get; set; }

            [Column("use_stacked_items_zgphoto", TypeName = "json")]

            public string? UseStackedItemsZgPhoto { get; set; }

            [Column("mhqwbcwhyx_zgphoto", TypeName = "json")]

            public string? MhqwbcwhyxZgPhoto { get; set; }

            [Column("jyplmhxtwbcwhyx_zgphoto", TypeName = "json")]

            public string? JyplmhxtwbcwhyxZgPhoto { get; set; }

            [Column("ygbjwfwhyx_msg_zgphoto", TypeName = "json")]

            public string? YgbjwfwhyxMsgZgPhoto { get; set; }

            [Column("slljdx")]
            public short? Slljdx { get; set; }

            [Column("slljdx_photo", TypeName = "json")]

            public string? SlljdxPhoto { get; set; }

            [Column("slljdx_msg")]
            [StringLength(255)]
            public string? SlljdxMsg { get; set; }

            [Column("slljdx_zgqk")]
            public short? SlljdxZgqk { get; set; }

            [Column("slljdx_zgphoto", TypeName = "json")]

            public string? SlljdxZgPhoto { get; set; }

            [Column("zxqlddcsl")]
            public short? Zxqlddcsl { get; set; }

            [Column("zxqlyhsyqsl")]
            public short? Zxqlyhsyqsl { get; set; }

            [Column("sign")]
            [StringLength(255)]
            public string? Sign { get; set; }

            [Column("notes")]
            [StringLength(255)]
            public string? Notes { get; set; }

            [Column("create_by")]
            [StringLength(50)]
            public string? CreateBy { get; set; }

            [Column("create_on")]
            public DateTime CreateOn { get; set; }

            [Column("create_ip")]
            [StringLength(20)]
            public string? CreateIp { get; set; }

            [Column("modified_by")]
            [StringLength(50)]
            public string? ModifiedBy { get; set; }

            [Column("modified_on")]
            public DateTime? ModifiedOn { get; set; }

            [Column("modified_ip")]
            [StringLength(20)]
            public string? ModifiedIp { get; set; }

            [Column("is_delete")]
            public short? IsDelete { get; set; }

            [Column("delete_by")]
            [StringLength(50)]
            public string? DeleteBy { get; set; }

            [Column("delete_on")]
            public DateTime? DeleteOn { get; set; }

            [Column("delete_ip")]
            [StringLength(20)]
            public string? DeleteIp { get; set; }

            [Column("pcsj")]
            [StringLength(255)]
            public DateTime? Pcsj { get; set; }

            [Column("jczt")]
            [StringLength(255)]
            public string? Jczt { get; set; }


            [Column("txxxysjbf")]
            public int? Txxxysjbf { get; set; }


            [Column("bzsm")]
            public string? Bzsm { get; set; }

            [Column("xzqdm")]
            public string? Xzqdm { get; set; }

            [Column("town")]
            public string? Town { get; set; }

            [Column("village")]
            public string? Village { get; set; }


            [Column("xzq")]
            public string? Xzq { get; set; }

            [Column("towndm")]
            public string? Towndm { get; set; }

            [Column("villagedm")]
            public string? Villagedm { get; set; }



        }



        public partial class ZmPcYhLogCjDto2
        {

            [Key]
            [Column("id")]
            [StringLength(50)]
            public string Id { get; set; }

            [Column("fwbh")]
            [StringLength(50)]
            public string? Fwbh { get; set; }

            // 下面是第二个表的字段信息
            [Column("pczt")]
            public short? Pczt { get; set; }


            // 下面是第二个表的字段信息
            [Column("pc_yh_id")]
            public string? PcYhId { get; set; }


            // 下面是第二个表的字段信息
            [Column("base_id")]
            public string? BaseId { get; set; }

            [Column("jcly")]
            public short? Jcly { get; set; }

            [Column("use_electric_bicycle")]
            public short? UseElectricBicycle { get; set; }

            [Column("use_bottled_liquefied_gas")]
            public short? UseBottledLiquefiedGas { get; set; }

            [Column("use_stacked_items")]
            public short? UseStackedItems { get; set; }

            [Column("mhqwbcwhyx")]
            public short? Mhqwbcwhyx { get; set; }

            [Column("jyplmhxtwbcwhyx")]
            public short? Jyplmhxtwbcwhyx { get; set; }

            [Column("ygbjwfwhyx")]
            public short? Ygbjwfwhyx { get; set; }

            [Column("use_electric_bicycle_photo", TypeName = "json")]
            public string? UseElectricBicyclePhoto { get; set; }

            [Column("use_bottled_liquefied_gas_photo", TypeName = "json")]

            public string? UseBottledLiquefiedGasPhoto { get; set; }

            [Column("use_stacked_items_photo", TypeName = "json")]

            public string? UseStackedItemsPhoto { get; set; }

            [Column("mhqwbcwhyx_photo", TypeName = "json")]

            public string? MhqwbcwhyxPhoto { get; set; }

            [Column("jyplmhxtwbcwhyx_photo", TypeName = "json")]

            public string? JyplmhxtwbcwhyxPhoto { get; set; }

            [Column("ygbjwfwhyx_photo", TypeName = "json")]

            public string? YgbjwfwhyxPhoto { get; set; }

            [Column("use_electric_bicycle_msg")]
            [StringLength(1000)]
            public string? UseElectricBicycleMsg { get; set; }

            [Column("use_bottled_liquefied_gas_msg")]
            [StringLength(1000)]
            public string? UseBottledLiquefiedGasMsg { get; set; }

            [Column("use_stacked_items_msg")]
            [StringLength(1000)]
            public string? UseStackedItemsMsg { get; set; }

            [Column("mhqwbcwhyx_msg")]
            [StringLength(1000)]
            public string? MhqwbcwhyxMsg { get; set; }

            [Column("jyplmhxtwbcwhyx_msg")]
            [StringLength(1000)]
            public string? JyplmhxtwbcwhyxMsg { get; set; }

            [Column("ygbjwfwhyx_msg")]
            [StringLength(1000)]
            public string? YgbjwfwhyxMsg { get; set; }

            [Column("use_electric_bicycle_zgqk")]
            public short? UseElectricBicycleZgqk { get; set; }

            [Column("use_bottled_liquefied_gas_zgqk")]
            public short? UseBottledLiquefiedGasZgqk { get; set; }

            [Column("use_stacked_items_zgqk")]
            public short? UseStackedItemsZgqk { get; set; }

            [Column("mhqwbcwhyx_zgqk")]
            public short? MhqwbcwhyxZgqk { get; set; }

            [Column("jyplmhxtwbcwhyx_zgqk")]
            public short? JyplmhxtwbcwhyxZgqk { get; set; }

            [Column("ygbjwfwhyx_msg_zgqk")]
            public short? YgbjwfwhyxMsgZgqk { get; set; }

            [Column("use_electric_bicycle_zgphoto", TypeName = "json")]

            public string? UseElectricBicycleZgPhoto { get; set; }

            [Column("use_bottled_liquefied_gas_zgphoto", TypeName = "json")]

            public string? UseBottledLiquefiedGasZgPhoto { get; set; }

            [Column("use_stacked_items_zgphoto", TypeName = "json")]

            public string? UseStackedItemsZgPhoto { get; set; }

            [Column("mhqwbcwhyx_zgphoto", TypeName = "json")]

            public string? MhqwbcwhyxZgPhoto { get; set; }

            [Column("jyplmhxtwbcwhyx_zgphoto", TypeName = "json")]

            public string? JyplmhxtwbcwhyxZgPhoto { get; set; }

            [Column("ygbjwfwhyx_msg_zgphoto", TypeName = "json")]

            public string? YgbjwfwhyxMsgZgPhoto { get; set; }

            [Column("slljdx")]
            public short? Slljdx { get; set; }

            [Column("slljdx_photo", TypeName = "json")]

            public string? SlljdxPhoto { get; set; }

            [Column("slljdx_msg")]
            [StringLength(255)]
            public string? SlljdxMsg { get; set; }

            [Column("slljdx_zgqk")]
            public short? SlljdxZgqk { get; set; }

            [Column("slljdx_zgphoto", TypeName = "json")]

            public string? SlljdxZgPhoto { get; set; }

            [Column("zxqlddcsl")]
            public short? Zxqlddcsl { get; set; }

            [Column("zxqlyhsyqsl")]
            public short? Zxqlyhsyqsl { get; set; }

            [Column("sign")]
            [StringLength(255)]
            public string? Sign { get; set; }

            [Column("notes")]
            [StringLength(255)]
            public string? Notes { get; set; }

            [Column("create_by")]
            [StringLength(50)]
            public string? CreateBy { get; set; }

            [Column("create_on")]
            public string CreateOn { get; set; }

            [Column("create_ip")]
            [StringLength(20)]
            public string? CreateIp { get; set; }

            [Column("modified_by")]
            [StringLength(50)]
            public string? ModifiedBy { get; set; }

            [Column("modified_on")]
            public string? ModifiedOn { get; set; }

            [Column("modified_ip")]
            [StringLength(20)]
            public string? ModifiedIp { get; set; }

            [Column("is_delete")]
            public short? IsDelete { get; set; }

            [Column("delete_by")]
            [StringLength(50)]
            public string? DeleteBy { get; set; }

            [Column("delete_on")]
            public string? DeleteOn { get; set; }

            [Column("delete_ip")]
            [StringLength(20)]
            public string? DeleteIp { get; set; }

            [Column("pcsj")]
            [StringLength(255)]
            public string? Pcsj { get; set; }

            [Column("jczt")]
            [StringLength(255)]
            public string? Jczt { get; set; }


            [Column("txxxysjbf")]
            public int? Txxxysjbf { get; set; }


            [Column("bzsm")]
            public string? Bzsm { get; set; }

            [Column("xzqdm")]
            public string? Xzqdm { get; set; }

            [Column("town")]
            public string? Town { get; set; }

            [Column("village")]
            public string? Village { get; set; }


            [Column("xzq")]
            public string? Xzq { get; set; }

            [Column("towndm")]
            public string? Towndm { get; set; }

            [Column("villagedm")]
            public string? Villagedm { get; set; }



        }




        [Table("zm_pc_baselog_cj")]
        public partial class ZmPcBaseLogCj : Repository.IEntity
        {
            [Key]
            [Column("id")]
            [StringLength(50)]
            public string Id { get; set; }

            [Column("fwbh")]
            [StringLength(50)]
            public string Fwbh { get; set; }

            //[Column("city")]
            //[StringLength(6)]
            //public string City { get; set; }
            [Column("cjzwqtjyyt")]
            public int? Cjzwqtjyyt { get; set; }

            [Column("xzqdm")]
            public string? Xzqdm { get; set; }

            [Column("town")]
            public string? Town { get; set; }

            [Column("village")]
            public string? Village { get; set; }


            [Column("xzq")]
            [StringLength(6)]
            public string Xzqname { get; set; }

            [Column("towndm")]
            [StringLength(12)]
            public string Townname { get; set; }

            [Column("villagedm")]
            [StringLength(12)]
            public string Villagename { get; set; }

            //[Column("xzq")]
            //public string? Xzq { get; set; }

            //[Column("towndm")]
            //public string? Towndm { get; set; }

            //[Column("villagedm")]
            //public string? Villagedm { get; set; }

            [Column("address")]
            [StringLength(254)]
            public string Address { get; set; }

            [Column("yhfwbh")]
            [StringLength(36)]
            public string Yhfwbh { get; set; }

            [Column("hzxm")]
            [StringLength(36)]
            public string Hzxm { get; set; }

            [Column("cs")]
            public long? Cs { get; set; }

            [Column("jzrks")]
            public int? Jzrks { get; set; }

            [Column("zzrs")]
            public int? Zzrs { get; set; }

            [Column("jzfjs")]
            public int? Jzfjs { get; set; }

            [Column("fjsl")]
            public int? Fjsl { get; set; }

            [Column("jzscxyaqcksl")]
            public int? Jzscxyaqcksl { get; set; }

            [Column("jzscmj")]
            public decimal? Jzscmj { get; set; }

            [Column("jzszlwxdlgybjqs")]
            public int? Jzszlwxdlgybjqs { get; set; }

            [Column("jzsyjyplmhxts")]
            public int? Jzsyjyplmhxts { get; set; }

            [Column("jzxyssltsl")]
            public int? Jzxyssltsl { get; set; }

            [Column("mhqsl")]
            public int? Mhqsl { get; set; }

            [Column("fytsmz")]
            public int? Fytsmz { get; set; }

            [Column("xggdjsbp")]
            public int? Xggdjsbp { get; set; }

            [Column("jsrysstd")]
            [StringLength(100)]
            public string Jsrysstd { get; set; }

            //[Column("sfazzzryslpbfytsmd")]
            //public int? Sfazzzryslpbfytsmd { get; set; }

            [Column("cjzwqtjyytmsg")]
            [StringLength(100)]
            public string Cjzwqtjyytmsg { get; set; }

            [Column("ckfhwggptzlsl")]
            public int? Ckfhwggptzlsl { get; set; }

            [Column("gryssdcsszblyyqksddp")]
            public int? Gryssdcsszblyyqksddp { get; set; }

            [Column("wdwhjgfjgqsyyrkrgbdj")]
            public int? Wdwhjgfjgqsyyrkrgbdj { get; set; }

            [Column("sstdjsqk")]
            [StringLength(100)]
            public string Sstdjsqk { get; set; }

            [Column("create_by")]
            [StringLength(50)]
            public string CreateBy { get; set; }

            [Column("create_on")]
            public DateTime CreateOn { get; set; }

            [Column("create_ip")]
            [StringLength(20)]
            public string CreateIp { get; set; }

            [Column("modified_by")]
            [StringLength(50)]
            public string ModifiedBy { get; set; }

            [Column("modified_on")]
            public DateTime? ModifiedOn { get; set; }

            [Column("modified_ip")]
            [StringLength(20)]
            public string ModifiedIp { get; set; }

            [Column("is_delete")]
            public short? IsDelete { get; set; }

            [Column("delete_by")]
            [StringLength(50)]
            public string DeleteBy { get; set; }

            [Column("delete_on")]
            public DateTime? DeleteOn { get; set; }

            [Column("delete_ip")]
            [StringLength(20)]
            public string DeleteIp { get; set; }

            [Column("bdfwjzrydddzxcsl")]
            public int? Bdfwjzrydddzxcsl { get; set; }

            [Column("sstdsyyrkrclzx")]
            public int? Sstdsyyrkrclzx { get; set; }

            [Column("pcsj")]
            public DateTime? Pcsj { get; set; }

            [Column("yhly")]
            public int? Yhly { get; set; }


            [Column("fwyfwdddzxccdsssfayqjshsf")]
            public int? Fwyfwdddzxccdsssfayqjshsf { get; set; }

            [Column("sfszsszsbzhaqckbz")]
            public int? Sfszsszsbzhaqckbz { get; set; }

            [Column("fwzt")]
            public int? Fwzt { get; set; }

            [Column("cdfs")]
            public string? Cdfs { get; set; }

            [Column("cdfsqtbz")]
            public string? Cdfsqtbz { get; set; }


            [Column("czryrs")]
            public int? Czryrs { get; set; }
            [Column("create_name")]
            public string? CreateName { get; set; }

            [Column("sfazfztsss")]
            public int? Sfazfztsss { get; set; }

            [Column("sfyzc")]
            public string? Sfyzc { get; set; }


            [Column("ywgdlttxwd")]
            public int? Ywgdlttxwd { get; set; }
        }



        public partial class ZmPcBaseLogCjDto 
        {
            [Key]
            [Column("id")]
            [StringLength(50)]
            public string Id { get; set; }

            [Column("fwbh")]
            [StringLength(50)]
            public string Fwbh { get; set; }

            //[Column("city")]
            //[StringLength(6)]
            //public string City { get; set; }
            [Column("cjzwqtjyyt")]
            public int? Cjzwqtjyyt { get; set; }

            [Column("xzqdm")]
            public string? Xzqdm { get; set; }

            [Column("town")]
            public string? Town { get; set; }

            [Column("village")]
            public string? Village { get; set; }


            [Column("xzq")]
            [StringLength(6)]
            public string Xzqname { get; set; }

            [Column("towndm")]
            [StringLength(12)]
            public string Townname { get; set; }

            [Column("villagedm")]
            [StringLength(12)]
            public string Villagename { get; set; }

            //[Column("xzq")]
            //public string? Xzq { get; set; }

            //[Column("towndm")]
            //public string? Towndm { get; set; }

            //[Column("villagedm")]
            //public string? Villagedm { get; set; }

            [Column("address")]
            [StringLength(254)]
            public string Address { get; set; }

            [Column("yhfwbh")]
            [StringLength(36)]
            public string Yhfwbh { get; set; }

            [Column("hzxm")]
            [StringLength(36)]
            public string Hzxm { get; set; }

            [Column("cs")]
            public long? Cs { get; set; }

            [Column("jzrks")]
            public int? Jzrks { get; set; }

            [Column("zzrs")]
            public int? Zzrs { get; set; }

            [Column("jzfjs")]
            public int? Jzfjs { get; set; }

            [Column("fjsl")]
            public int? Fjsl { get; set; }

            [Column("jzscxyaqcksl")]
            public int? Jzscxyaqcksl { get; set; }

            [Column("jzscmj")]
            public decimal? Jzscmj { get; set; }

            [Column("jzszlwxdlgybjqs")]
            public int? Jzszlwxdlgybjqs { get; set; }

            [Column("jzsyjyplmhxts")]
            public int? Jzsyjyplmhxts { get; set; }

            [Column("jzxyssltsl")]
            public int? Jzxyssltsl { get; set; }

            [Column("mhqsl")]
            public int? Mhqsl { get; set; }

            [Column("fytsmz")]
            public int? Fytsmz { get; set; }

            [Column("xggdjsbp")]
            public int? Xggdjsbp { get; set; }

            [Column("jsrysstd")]
            [StringLength(100)]
            public string Jsrysstd { get; set; }

            //[Column("sfazzzryslpbfytsmd")]
            //public int? Sfazzzryslpbfytsmd { get; set; }

            [Column("cjzwqtjyytmsg")]
            [StringLength(100)]
            public string Cjzwqtjyytmsg { get; set; }

            [Column("ckfhwggptzlsl")]
            public int? Ckfhwggptzlsl { get; set; }

            [Column("gryssdcsszblyyqksddp")]
            public int? Gryssdcsszblyyqksddp { get; set; }

            [Column("wdwhjgfjgqsyyrkrgbdj")]
            public int? Wdwhjgfjgqsyyrkrgbdj { get; set; }

            [Column("sstdjsqk")]
            [StringLength(100)]
            public string Sstdjsqk { get; set; }

            [Column("create_by")]
            [StringLength(50)]
            public string CreateBy { get; set; }

            [Column("create_on")]
            public string CreateOn { get; set; }

            [Column("create_ip")]
            [StringLength(20)]
            public string CreateIp { get; set; }

            [Column("modified_by")]
            [StringLength(50)]
            public string ModifiedBy { get; set; }

            [Column("modified_on")]
            public string? ModifiedOn { get; set; }

            [Column("modified_ip")]
            [StringLength(20)]
            public string ModifiedIp { get; set; }

            [Column("is_delete")]
            public short? IsDelete { get; set; }

            [Column("delete_by")]
            [StringLength(50)]
            public string DeleteBy { get; set; }

            [Column("delete_on")]
            public string? DeleteOn { get; set; }

            [Column("delete_ip")]
            [StringLength(20)]
            public string DeleteIp { get; set; }

            [Column("bdfwjzrydddzxcsl")]
            public int? Bdfwjzrydddzxcsl { get; set; }

            [Column("sstdsyyrkrclzx")]
            public int? Sstdsyyrkrclzx { get; set; }

            [Column("pcsj")]
            public string Pcsj { get; set; }

            [Column("yhly")]
            public int? Yhly { get; set; }


            [Column("fwyfwdddzxccdsssfayqjshsf")]
            public int? Fwyfwdddzxccdsssfayqjshsf { get; set; }

            [Column("sfszsszsbzhaqckbz")]
            public int? Sfszsszsbzhaqckbz { get; set; }

            [Column("fwzt")]
            public int? Fwzt { get; set; }

            [Column("cdfs")]
            public string? Cdfs { get; set; }

            [Column("cdfsqtbz")]
            public string? Cdfsqtbz { get; set; }


            [Column("czryrs")]
            public int? Czryrs { get; set; }
            [Column("create_name")]
            public string? CreateName { get; set; }

            [Column("sfazfztsss")]
            public int? Sfazfztsss { get; set; }

            [Column("sfyzc")]
            public string? Sfyzc { get; set; }


            [Column("ywgdlttxwd")]
            public int? Ywgdlttxwd { get; set; }
        }
    }
}
